package com.hcrazy.manchester.app.jdbc;

import java.util.List;

import com.hcrazy.manchester.app.pojo.City;

public class CityDAO extends BaseDAO<City>{

	
	public List<City> getAllCities() throws Exception{
		String sql = "select a.*,b.provinceName from him_town_city a,him_town_province b where a.provinceId = b.provinceId";
		
		return getList(sql, City.class);
	}
	
	
}
